package test

import java.io.File
import implicits.Implicits._

/**
 * Created by yz on 13/5/2020
 */
object Test1 {

  def main(args: Array[String]): Unit = {

    val parent = new File("C:\\forensic_database\\test")
//    val file = new File(parent, "V300036935肇庆血卡信息.xlsx")
//    val map = file.xlsxLines().map { columns =>
//      (columns(0) -> columns(5))
//    }.toMap
//    println(map)

    val file=new File(parent,"kit.xlsx")
    val siteNames=file.xlsxLines().lineMapNoLower.map{map=>
      map("YSUPP")
    }.map("\""+_+"\"")
    println(siteNames)

    //    val file = new File(parent, "19014-2-GenoY41.dat")
    //    val lines = file.lines
    //    val siteNames = lines.zipWithIndex.filter { case (line, i) =>
    //      line.startsWith("gmidx")
    //    }.map { case (line, i) =>
    //      lines(i - 2)
    //    }.toList.distinct
    //    println(siteNames.map("\""+_+"\""))
    //    println(siteNames.size)

  }

}
